Database Test

This is the most difficult task to implement correctly.  Please read this entire documentation very carefully.

This utility helps you to test your connection to a database.  It connects to your database using an intermediate JDBC (Java Database Connectivity) driver. A database vendor or third party vendor provides this driver.  Detailed JDBC driver and connection information for popular databases like MSAccess, Oracle, Informix, MySql, mSql, Postgres are included in our knowledge base. The knowledge base is online at www.hiteksoftware.com. Go to our main support page and use the knowledge base link. Our knowledge base has information on these databases, and other databases provided by our users. 

Detailed information on JDBC drivers, that are available for most databases, is provided by www.javasoft.com.  Please read the JDBC driver documentation very carefully. The driver documentation will specify the values for the Driver Class Name and Database Url. 

Database JDBC driver
For your database, you need to obtain the JDBC driver from your database vendor or other 3rd party vendor.  The commercial database vendors have free JDBC drivers available at their web site.  Legal issues may prevent us from redistributing some of these free JDBC drivers, in our software or, at our web site.

The JDBC driver is generally in the form of a .zip or .jar file. You need to place the JDBC driver in the following folder depending on your installation method. Then restart the engine and the user interface.
For installs including JVM :  ...Automize/jre/lib/ext
For installs without JVM :  ...jre/1.3/lib/ext   or  JDK1.3/jre/lib/ext  etc.. depending on your system

Driver class name
Enter the class name for the driver.  This information will be available, in the driver documentation.  For Microsoft Access database, simply enter "access".  Also, the JDBC driver required for MSAccess is included within java itself.

Database Url
Enter the Url connection information.  This information will be available, in the Java JDBC driver documentation.
The Url format will vary with vendor, but generally includes the server name, port, and database name, username, and password.

Authorization
If your database requires authentication, then select this option and enter your username and password.

Username
Enter your username if required for database access.  It is case sensitive.

Password
Enter your password if required for database access.  It is case sensitive.